package com.tjy.wfx.dao;

import com.tjy.wfx.model.SysRole;
import org.apache.ibatis.annotations.Select;
import tk.mybatis.mapper.common.Mapper;

import java.util.List;

public interface SysRoleMapper extends Mapper<SysRole> {
    @Select(value = "select r.* from sys_role r, sys_user_role ur, user_info u \n" +
            "where u.user_id=ur.user_id and r.role_code = ur.role_id and u.account =#{account}")
     List<SysRole> findRole(String account);
}
